﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsUsers" targetNamespace="http://tempuri.org/dsUsers.xsd" xmlns:mstns="http://tempuri.org/dsUsers.xsd" xmlns="http://tempuri.org/dsUsers.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblUsersTableAdapter" GeneratorDataComponentClassName="tblUsersTableAdapter" Name="tblUsers" UserDataComponentName="tblUsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUsers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblUsers] WHERE (([cUserName] = @Original_cUserName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblUsers] ([idNhanSu], [idPhong], [iRoleID], [cUserName], [cPassword], [bActive], [bIsAdmin]) VALUES (@idNhanSu, @idPhong, @iRoleID, @cUserName, @cPassword, @bActive, @bIsAdmin);
SELECT idNhanSu, idPhong, iRoleID, cUserName, cPassword, bActive, bIsAdmin FROM tblUsers WHERE (cUserName = @cUserName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@idNhanSu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="idNhanSu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idPhong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iRoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPassword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bIsAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIsAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        idNhanSu, idPhong, iRoleID, cUserName, cPassword, bActive, bIsAdmin
FROM            tblUsers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblUsers] SET [idNhanSu] = @idNhanSu, [idPhong] = @idPhong, [iRoleID] = @iRoleID, [cUserName] = @cUserName, [cPassword] = @cPassword, [bActive] = @bActive, [bIsAdmin] = @bIsAdmin WHERE (([cUserName] = @Original_cUserName));
SELECT idNhanSu, idPhong, iRoleID, cUserName, cPassword, bActive, bIsAdmin FROM tblUsers WHERE (cUserName = @cUserName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@idNhanSu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="idNhanSu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idPhong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iRoleID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPassword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bIsAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIsAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idNhanSu" DataSetColumn="idNhanSu" />
              <Mapping SourceColumn="idPhong" DataSetColumn="idPhong" />
              <Mapping SourceColumn="iRoleID" DataSetColumn="iRoleID" />
              <Mapping SourceColumn="cUserName" DataSetColumn="cUserName" />
              <Mapping SourceColumn="cPassword" DataSetColumn="cPassword" />
              <Mapping SourceColumn="bActive" DataSetColumn="bActive" />
              <Mapping SourceColumn="bIsAdmin" DataSetColumn="bIsAdmin" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="ChangePass" Modifier="Public" Name="ChangePass" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="ChangePass">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblUsers
SET                cPassword = @cPassword
WHERE        (cUserName = @user); 
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="cPassword" ColumnName="cPassword" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@cPassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cPassword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="user" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@user" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUsers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByMaNhanSu" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByMaNhanSu" GeneratorSourceName="FillByMaNhanSu" GetMethodModifier="Public" GetMethodName="GetDataByMaNhanSu" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByMaNhanSu" UserSourceName="FillByMaNhanSu">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        idNhanSu, idPhong, iRoleID, cUserName, cPassword, bActive, bIsAdmin
FROM            tblUsers
where idNhanSu=@mans</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="mans" ColumnName="idNhanSu" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@mans" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="idNhanSu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUsers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserName" GeneratorSourceName="FillByUserName" GetMethodModifier="Public" GetMethodName="GetDataByUserName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserName" UserSourceName="FillByUserName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT bActive, bIsAdmin, cPassword, cUserName, iRoleID, idNhanSu, idPhong FROM tblUsers WHERE (cUserName = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUsers" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPhongID" GetMethodModifier="Public" GetMethodName="GetDataByPhongID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPhongID" UserSourceName="GetDataByPhongID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT bActive, bIsAdmin, cPassword, cUserName, iRoleID, idNhanSu, idPhong FROM tblUsers WHERE (idPhong = @phongid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="phongid" ColumnName="idPhong" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@phongid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idPhong" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUsers" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByRoleID" GetMethodModifier="Public" GetMethodName="GetDataByRoleID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByRoleID" UserSourceName="GetDataByRoleID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT bActive, bIsAdmin, cPassword, cUserName, iRoleID, idNhanSu, idPhong FROM tblUsers WHERE (iRoleID = @roleid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="roleid" ColumnName="iRoleID" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@roleid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iRoleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUsers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="login" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="login" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="login">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        idNhanSu, idPhong, iRoleID, cUserName, cPassword, bActive, bIsAdmin
FROM            tblUsers
where (cUserName=@username and cPassword=@pass)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="pass" ColumnName="cPassword" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cPassword" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUsers" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="selectIdNhanSu" Modifier="Public" Name="selectIdNhanSu" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="selectIdNhanSu">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT  top 1        idNhanSu
FROM            tblUsers
where cUserName=@username</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUsers" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="selectPass" Modifier="Public" Name="selectPass" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="selectPass">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        cPassword
FROM            tblUsers
WHERE        (cUserName = @userName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userName" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblUsers" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@userName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblPhongTableAdapter" GeneratorDataComponentClassName="tblPhongTableAdapter" Name="tblPhong" UserDataComponentName="tblPhongTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblPhong" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblPhong] WHERE (([iPhongId] = @Original_iPhongId) AND ((@IsNull_cTenPhong = 1 AND [cTenPhong] IS NULL) OR ([cTenPhong] = @Original_cTenPhong)) AND ((@IsNull_cMoTa = 1 AND [cMoTa] IS NULL) OR ([cMoTa] = @Original_cMoTa)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iPhongId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iPhongId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTenPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTenPhong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTenPhong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenPhong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMoTa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblPhong] ([cTenPhong], [cMoTa]) VALUES (@cTenPhong, @cMoTa);
SELECT iPhongId, cTenPhong, cMoTa FROM tblPhong WHERE (iPhongId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenPhong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenPhong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT iPhongId, cTenPhong, cMoTa FROM dbo.tblPhong</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblPhong] SET [cTenPhong] = @cTenPhong, [cMoTa] = @cMoTa WHERE (([iPhongId] = @Original_iPhongId) AND ((@IsNull_cTenPhong = 1 AND [cTenPhong] IS NULL) OR ([cTenPhong] = @Original_cTenPhong)) AND ((@IsNull_cMoTa = 1 AND [cMoTa] IS NULL) OR ([cMoTa] = @Original_cMoTa)));
SELECT iPhongId, cTenPhong, cMoTa FROM tblPhong WHERE (iPhongId = @iPhongId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenPhong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenPhong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iPhongId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iPhongId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTenPhong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTenPhong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTenPhong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenPhong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMoTa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="iPhongId" ColumnName="iPhongId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@iPhongId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iPhongId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="iPhongId" DataSetColumn="iPhongId" />
              <Mapping SourceColumn="cTenPhong" DataSetColumn="cTenPhong" />
              <Mapping SourceColumn="cMoTa" DataSetColumn="cMoTa" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblRoleTableAdapter" GeneratorDataComponentClassName="tblRoleTableAdapter" Name="tblRole" UserDataComponentName="tblRoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRole" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblRole] WHERE (([iRoleid] = @Original_iRoleid) AND ((@IsNull_cTenRole = 1 AND [cTenRole] IS NULL) OR ([cTenRole] = @Original_cTenRole)) AND ((@IsNull_cMoTa = 1 AND [cMoTa] IS NULL) OR ([cMoTa] = @Original_cMoTa)) AND ((@IsNull_bActive = 1 AND [bActive] IS NULL) OR ([bActive] = @Original_bActive)) AND ((@IsNull_bIsAdmin = 1 AND [bIsAdmin] IS NULL) OR ([bIsAdmin] = @Original_bIsAdmin)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iRoleid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRoleid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTenRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTenRole" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTenRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMoTa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bIsAdmin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bIsAdmin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bIsAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIsAdmin" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblRole] ([cTenRole], [cMoTa], [bActive], [bIsAdmin]) VALUES (@cTenRole, @cMoTa, @bActive, @bIsAdmin);
SELECT iRoleid, cTenRole, cMoTa, bActive, bIsAdmin FROM tblRole WHERE (iRoleid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bIsAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIsAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT iRoleid, cTenRole, cMoTa, bActive, bIsAdmin FROM dbo.tblRole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblRole] SET [cTenRole] = @cTenRole, [cMoTa] = @cMoTa, [bActive] = @bActive, [bIsAdmin] = @bIsAdmin WHERE (([iRoleid] = @Original_iRoleid) AND ((@IsNull_cTenRole = 1 AND [cTenRole] IS NULL) OR ([cTenRole] = @Original_cTenRole)) AND ((@IsNull_cMoTa = 1 AND [cMoTa] IS NULL) OR ([cMoTa] = @Original_cMoTa)) AND ((@IsNull_bActive = 1 AND [bActive] IS NULL) OR ([bActive] = @Original_bActive)) AND ((@IsNull_bIsAdmin = 1 AND [bIsAdmin] IS NULL) OR ([bIsAdmin] = @Original_bIsAdmin)));
SELECT iRoleid, cTenRole, cMoTa, bActive, bIsAdmin FROM tblRole WHERE (iRoleid = @iRoleid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bIsAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIsAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iRoleid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRoleid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTenRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTenRole" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTenRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMoTa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bIsAdmin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bIsAdmin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bIsAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIsAdmin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="iRoleid" ColumnName="iRoleid" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@iRoleid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iRoleid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="iRoleid" DataSetColumn="iRoleid" />
              <Mapping SourceColumn="cTenRole" DataSetColumn="cTenRole" />
              <Mapping SourceColumn="cMoTa" DataSetColumn="cMoTa" />
              <Mapping SourceColumn="bActive" DataSetColumn="bActive" />
              <Mapping SourceColumn="bIsAdmin" DataSetColumn="bIsAdmin" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblNhanSuTableAdapter" GeneratorDataComponentClassName="tblNhanSuTableAdapter" Name="tblNhanSu" UserDataComponentName="tblNhanSuTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblNhanSu" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblNhanSu] WHERE (((@IsNull_cTenNhanSu = 1 AND [cTenNhanSu] IS NULL) OR ([cTenNhanSu] = @Original_cTenNhanSu)) AND ((@IsNull_iPhongID = 1 AND [iPhongID] IS NULL) OR ([iPhongID] = @Original_iPhongID)) AND ((@IsNull_cDiaChi = 1 AND [cDiaChi] IS NULL) OR ([cDiaChi] = @Original_cDiaChi)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cSoDienThoai = 1 AND [cSoDienThoai] IS NULL) OR ([cSoDienThoai] = @Original_cSoDienThoai)) AND ((@IsNull_dNgaySinh = 1 AND [dNgaySinh] IS NULL) OR ([dNgaySinh] = @Original_dNgaySinh)) AND ((@IsNull_cChucVu = 1 AND [cChucVu] IS NULL) OR ([cChucVu] = @Original_cChucVu)) AND ((@IsNull_isMale = 1 AND [isMale] IS NULL) OR ([isMale] = @Original_isMale)) AND ([iNhanSuID] = @Original_iNhanSuID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTenNhanSu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTenNhanSu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTenNhanSu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenNhanSu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iPhongID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iPhongID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iPhongID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iPhongID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cSoDienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cSoDienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cSoDienThoai" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSoDienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNgaySinh" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cChucVu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cChucVu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cChucVu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cChucVu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isMale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isMale" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isMale" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isMale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iNhanSuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iNhanSuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblNhanSu] ([cTenNhanSu], [iPhongID], [cDiaChi], [pAnhDaiDien], [cEmail], [cSoDienThoai], [dNgaySinh], [cChucVu], [isMale]) VALUES (@cTenNhanSu, @iPhongID, @cDiaChi, @pAnhDaiDien, @cEmail, @cSoDienThoai, @dNgaySinh, @cChucVu, @isMale);
SELECT cTenNhanSu, iPhongID, cDiaChi, pAnhDaiDien, cEmail, cSoDienThoai, dNgaySinh, cChucVu, isMale, iNhanSuID FROM tblNhanSu WHERE (iNhanSuID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenNhanSu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenNhanSu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iPhongID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iPhongID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@pAnhDaiDien" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="pAnhDaiDien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cSoDienThoai" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSoDienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNgaySinh" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cChucVu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cChucVu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isMale" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isMale" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        cTenNhanSu, iPhongID, cDiaChi, pAnhDaiDien, cEmail, cSoDienThoai, dNgaySinh, cChucVu, isMale, iNhanSuID
FROM            tblNhanSu</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblNhanSu] SET [cTenNhanSu] = @cTenNhanSu, [iPhongID] = @iPhongID, [cDiaChi] = @cDiaChi, [pAnhDaiDien] = @pAnhDaiDien, [cEmail] = @cEmail, [cSoDienThoai] = @cSoDienThoai, [dNgaySinh] = @dNgaySinh, [cChucVu] = @cChucVu, [isMale] = @isMale WHERE (((@IsNull_cTenNhanSu = 1 AND [cTenNhanSu] IS NULL) OR ([cTenNhanSu] = @Original_cTenNhanSu)) AND ((@IsNull_iPhongID = 1 AND [iPhongID] IS NULL) OR ([iPhongID] = @Original_iPhongID)) AND ((@IsNull_cDiaChi = 1 AND [cDiaChi] IS NULL) OR ([cDiaChi] = @Original_cDiaChi)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cSoDienThoai = 1 AND [cSoDienThoai] IS NULL) OR ([cSoDienThoai] = @Original_cSoDienThoai)) AND ((@IsNull_dNgaySinh = 1 AND [dNgaySinh] IS NULL) OR ([dNgaySinh] = @Original_dNgaySinh)) AND ((@IsNull_cChucVu = 1 AND [cChucVu] IS NULL) OR ([cChucVu] = @Original_cChucVu)) AND ((@IsNull_isMale = 1 AND [isMale] IS NULL) OR ([isMale] = @Original_isMale)) AND ([iNhanSuID] = @Original_iNhanSuID));
SELECT cTenNhanSu, iPhongID, cDiaChi, pAnhDaiDien, cEmail, cSoDienThoai, dNgaySinh, cChucVu, isMale, iNhanSuID FROM tblNhanSu WHERE (iNhanSuID = @iNhanSuID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenNhanSu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenNhanSu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iPhongID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iPhongID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@pAnhDaiDien" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="pAnhDaiDien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cSoDienThoai" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSoDienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNgaySinh" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cChucVu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cChucVu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isMale" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isMale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTenNhanSu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTenNhanSu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTenNhanSu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenNhanSu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iPhongID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iPhongID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iPhongID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iPhongID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cSoDienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cSoDienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cSoDienThoai" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSoDienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNgaySinh" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cChucVu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cChucVu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cChucVu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cChucVu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isMale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isMale" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isMale" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isMale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iNhanSuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iNhanSuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="iNhanSuID" ColumnName="iNhanSuID" DataSourceName="CrewManagment.dbo.tblNhanSu" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@iNhanSuID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iNhanSuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cTenNhanSu" DataSetColumn="cTenNhanSu" />
              <Mapping SourceColumn="iPhongID" DataSetColumn="iPhongID" />
              <Mapping SourceColumn="cDiaChi" DataSetColumn="cDiaChi" />
              <Mapping SourceColumn="pAnhDaiDien" DataSetColumn="pAnhDaiDien" />
              <Mapping SourceColumn="cEmail" DataSetColumn="cEmail" />
              <Mapping SourceColumn="cSoDienThoai" DataSetColumn="cSoDienThoai" />
              <Mapping SourceColumn="dNgaySinh" DataSetColumn="dNgaySinh" />
              <Mapping SourceColumn="cChucVu" DataSetColumn="cChucVu" />
              <Mapping SourceColumn="isMale" DataSetColumn="isMale" />
              <Mapping SourceColumn="iNhanSuID" DataSetColumn="iNhanSuID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblNhanSu" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT cChucVu, cDiaChi, cEmail, cSoDienThoai, cTenNhanSu, dNgaySinh, iNhanSuID, iPhongID, isMale, pAnhDaiDien FROM tblNhanSu WHERE (iNhanSuID = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="iNhanSuID" DataSourceName="CrewManagment.dbo.tblNhanSu" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="iNhanSuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblNhanSu" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPhongID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPhongID" GeneratorSourceName="FillByPhongID" GetMethodModifier="Public" GetMethodName="GetDataByPhongID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPhongID" UserSourceName="FillByPhongID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT cChucVu, cDiaChi, cEmail, cSoDienThoai, cTenNhanSu, dNgaySinh, iNhanSuID, iPhongID, isMale, pAnhDaiDien FROM tblNhanSu WHERE (iPhongID = @phongid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="phongid" ColumnName="iPhongID" DataSourceName="CrewManagment.dbo.tblNhanSu" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@phongid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iPhongID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblNhanSu" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="selectTenNhanSu" Modifier="Public" Name="selectTenNhanSu" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="selectTenNhanSu">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT cTenNhanSu FROM tblNhanSu WHERE (iNhanSuID = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="iNhanSuID" DataSourceName="CrewManagment.dbo.tblNhanSu" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iNhanSuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblQuyenTableAdapter" GeneratorDataComponentClassName="tblQuyenTableAdapter" Name="tblQuyen" UserDataComponentName="tblQuyenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblQuyen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblQuyen] WHERE (([iQuyenID] = @Original_iQuyenID) AND ([cUserName] = @Original_cUserName) AND ([iItemID] = @Original_iItemID) AND ((@IsNull_isAdmin = 1 AND [isAdmin] IS NULL) OR ([isAdmin] = @Original_isAdmin)) AND ((@IsNull_cItemTitle = 1 AND [cItemTitle] IS NULL) OR ([cItemTitle] = @Original_cItemTitle)) AND ((@IsNull_cItemKey = 1 AND [cItemKey] IS NULL) OR ([cItemKey] = @Original_cItemKey)) AND ((@IsNull_iParentID = 1 AND [iParentID] IS NULL) OR ([iParentID] = @Original_iParentID)) AND ((@IsNull_ControlInMain = 1 AND [ControlInMain] IS NULL) OR ([ControlInMain] = @Original_ControlInMain)) AND ((@IsNull_cTenQuyen = 1 AND [cTenQuyen] IS NULL) OR ([cTenQuyen] = @Original_cTenQuyen)) AND ((@IsNull_cMoTa = 1 AND [cMoTa] IS NULL) OR ([cMoTa] = @Original_cMoTa)) AND ((@IsNull_bFull = 1 AND [bFull] IS NULL) OR ([bFull] = @Original_bFull)) AND ((@IsNull_bTruyCap = 1 AND [bTruyCap] IS NULL) OR ([bTruyCap] = @Original_bTruyCap)) AND ((@IsNull_bThem = 1 AND [bThem] IS NULL) OR ([bThem] = @Original_bThem)) AND ((@IsNull_bSua = 1 AND [bSua] IS NULL) OR ([bSua] = @Original_bSua)) AND ((@IsNull_bXoa = 1 AND [bXoa] IS NULL) OR ([bXoa] = @Original_bXoa)) AND ((@IsNull_bIn = 1 AND [bIn] IS NULL) OR ([bIn] = @Original_bIn)) AND ((@IsNull_bNhap = 1 AND [bNhap] IS NULL) OR ([bNhap] = @Original_bNhap)) AND ((@IsNull_bXuat = 1 AND [bXuat] IS NULL) OR ([bXuat] = @Original_bXuat)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iQuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iQuyenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isAdmin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isAdmin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isAdmin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemTitle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ControlInMain" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ControlInMain" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ControlInMain" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ControlInMain" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTenQuyen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTenQuyen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTenQuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenQuyen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMoTa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bFull" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bFull" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bFull" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bFull" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bTruyCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bTruyCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bTruyCap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bTruyCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bThem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bThem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bThem" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bThem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bSua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bSua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bSua" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bSua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bXoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bXoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bXoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bIn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bIn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bIn" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bNhap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bNhap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bNhap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bNhap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bXuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bXuat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bXuat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblQuyen] ([cUserName], [iItemID], [isAdmin], [cItemTitle], [cItemKey], [iParentID], [ControlInMain], [cTenQuyen], [cMoTa], [bFull], [bTruyCap], [bThem], [bSua], [bXoa], [bIn], [bNhap], [bXuat]) VALUES (@cUserName, @iItemID, @isAdmin, @cItemTitle, @cItemKey, @iParentID, @ControlInMain, @cTenQuyen, @cMoTa, @bFull, @bTruyCap, @bThem, @bSua, @bXoa, @bIn, @bNhap, @bXuat);
SELECT iQuyenID, cUserName, iItemID, isAdmin, cItemTitle, cItemKey, iParentID, ControlInMain, cTenQuyen, cMoTa, bFull, bTruyCap, bThem, bSua, bXoa, bIn, bNhap, bXuat FROM tblQuyen WHERE (cUserName = @cUserName) AND (iItemID = @iItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ControlInMain" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ControlInMain" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenQuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenQuyen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bFull" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bFull" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bTruyCap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bTruyCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bThem" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bThem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bSua" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bSua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bXoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bIn" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bNhap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bNhap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bXuat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        iQuyenID, cUserName, iItemID, isAdmin, cItemTitle, cItemKey, iParentID, ControlInMain, cTenQuyen, cMoTa, bFull, bTruyCap, bThem, bSua, bXoa, bIn, bNhap, 
                         bXuat
FROM            tblQuyen</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblQuyen] SET [cUserName] = @cUserName, [iItemID] = @iItemID, [isAdmin] = @isAdmin, [cItemTitle] = @cItemTitle, [cItemKey] = @cItemKey, [iParentID] = @iParentID, [ControlInMain] = @ControlInMain, [cTenQuyen] = @cTenQuyen, [cMoTa] = @cMoTa, [bFull] = @bFull, [bTruyCap] = @bTruyCap, [bThem] = @bThem, [bSua] = @bSua, [bXoa] = @bXoa, [bIn] = @bIn, [bNhap] = @bNhap, [bXuat] = @bXuat WHERE (([iQuyenID] = @Original_iQuyenID) AND ([cUserName] = @Original_cUserName) AND ([iItemID] = @Original_iItemID) AND ((@IsNull_isAdmin = 1 AND [isAdmin] IS NULL) OR ([isAdmin] = @Original_isAdmin)) AND ((@IsNull_cItemTitle = 1 AND [cItemTitle] IS NULL) OR ([cItemTitle] = @Original_cItemTitle)) AND ((@IsNull_cItemKey = 1 AND [cItemKey] IS NULL) OR ([cItemKey] = @Original_cItemKey)) AND ((@IsNull_iParentID = 1 AND [iParentID] IS NULL) OR ([iParentID] = @Original_iParentID)) AND ((@IsNull_ControlInMain = 1 AND [ControlInMain] IS NULL) OR ([ControlInMain] = @Original_ControlInMain)) AND ((@IsNull_cTenQuyen = 1 AND [cTenQuyen] IS NULL) OR ([cTenQuyen] = @Original_cTenQuyen)) AND ((@IsNull_cMoTa = 1 AND [cMoTa] IS NULL) OR ([cMoTa] = @Original_cMoTa)) AND ((@IsNull_bFull = 1 AND [bFull] IS NULL) OR ([bFull] = @Original_bFull)) AND ((@IsNull_bTruyCap = 1 AND [bTruyCap] IS NULL) OR ([bTruyCap] = @Original_bTruyCap)) AND ((@IsNull_bThem = 1 AND [bThem] IS NULL) OR ([bThem] = @Original_bThem)) AND ((@IsNull_bSua = 1 AND [bSua] IS NULL) OR ([bSua] = @Original_bSua)) AND ((@IsNull_bXoa = 1 AND [bXoa] IS NULL) OR ([bXoa] = @Original_bXoa)) AND ((@IsNull_bIn = 1 AND [bIn] IS NULL) OR ([bIn] = @Original_bIn)) AND ((@IsNull_bNhap = 1 AND [bNhap] IS NULL) OR ([bNhap] = @Original_bNhap)) AND ((@IsNull_bXuat = 1 AND [bXuat] IS NULL) OR ([bXuat] = @Original_bXuat)));
SELECT iQuyenID, cUserName, iItemID, isAdmin, cItemTitle, cItemKey, iParentID, ControlInMain, cTenQuyen, cMoTa, bFull, bTruyCap, bThem, bSua, bXoa, bIn, bNhap, bXuat FROM tblQuyen WHERE (cUserName = @cUserName) AND (iItemID = @iItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ControlInMain" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ControlInMain" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTenQuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenQuyen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bFull" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bFull" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bTruyCap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bTruyCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bThem" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bThem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bSua" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bSua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bXoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bIn" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bNhap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bNhap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bXuat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXuat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iQuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iQuyenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isAdmin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isAdmin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isAdmin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemTitle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ControlInMain" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ControlInMain" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ControlInMain" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ControlInMain" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTenQuyen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTenQuyen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTenQuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTenQuyen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMoTa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMoTa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMoTa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bFull" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bFull" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bFull" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bFull" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bTruyCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bTruyCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bTruyCap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bTruyCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bThem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bThem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bThem" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bThem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bSua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bSua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bSua" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bSua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bXoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bXoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bXoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bIn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bIn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bIn" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bIn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bNhap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bNhap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bNhap" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bNhap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bXuat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bXuat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bXuat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bXuat" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="iQuyenID" DataSetColumn="iQuyenID" />
              <Mapping SourceColumn="cUserName" DataSetColumn="cUserName" />
              <Mapping SourceColumn="iItemID" DataSetColumn="iItemID" />
              <Mapping SourceColumn="cItemTitle" DataSetColumn="cItemTitle" />
              <Mapping SourceColumn="cItemKey" DataSetColumn="cItemKey" />
              <Mapping SourceColumn="iParentID" DataSetColumn="iParentID" />
              <Mapping SourceColumn="cTenQuyen" DataSetColumn="cTenQuyen" />
              <Mapping SourceColumn="cMoTa" DataSetColumn="cMoTa" />
              <Mapping SourceColumn="bFull" DataSetColumn="bFull" />
              <Mapping SourceColumn="bTruyCap" DataSetColumn="bTruyCap" />
              <Mapping SourceColumn="bThem" DataSetColumn="bThem" />
              <Mapping SourceColumn="bSua" DataSetColumn="bSua" />
              <Mapping SourceColumn="bXoa" DataSetColumn="bXoa" />
              <Mapping SourceColumn="bIn" DataSetColumn="bIn" />
              <Mapping SourceColumn="bNhap" DataSetColumn="bNhap" />
              <Mapping SourceColumn="bXuat" DataSetColumn="bXuat" />
              <Mapping SourceColumn="isAdmin" DataSetColumn="isAdmin" />
              <Mapping SourceColumn="ControlInMain" DataSetColumn="ControlInMain" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblQuyen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserName" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByUserName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByUserName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ControlInMain, bFull, bIn, bNhap, bSua, bThem, bTruyCap, bXoa, bXuat, cItemKey, cItemTitle, cMoTa, cTenQuyen, cUserName, iItemID, iParentID, iQuyenID, isAdmin FROM tblQuyen WHERE (cUserName = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="getItem" Modifier="Public" Name="getItem" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="getItem">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO tblQuyen
                         (cUserName, isAdmin, iItemID, cItemTitle, cItemKey, iParentID, ControlInMain)
VALUES        (@cUserName,@isAdmin,@iItemID,@cItemTitle,@cItemKey,@iParentID,@ControlInMain)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="cUserName" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="isAdmin" ColumnName="isAdmin" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isAdmin" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="isAdmin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="iItemID" ColumnName="iItemID" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@iItemID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="cItemTitle" ColumnName="cItemTitle" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="cItemKey" ColumnName="cItemKey" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="iParentID" ColumnName="iParentID" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@iParentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ControlInMain" ColumnName="ControlInMain" DataSourceName="CrewManagment.dbo.tblQuyen" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@ControlInMain" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="ControlInMain" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblItemsTableAdapter" GeneratorDataComponentClassName="tblItemsTableAdapter" Name="tblItems" UserDataComponentName="tblItemsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblItems] WHERE (([iItemID] = @Original_iItemID) AND ((@IsNull_cItemTitle = 1 AND [cItemTitle] IS NULL) OR ([cItemTitle] = @Original_cItemTitle)) AND ((@IsNull_cItemKey = 1 AND [cItemKey] IS NULL) OR ([cItemKey] = @Original_cItemKey)) AND ((@IsNull_cItemDescription = 1 AND [cItemDescription] IS NULL) OR ([cItemDescription] = @Original_cItemDescription)) AND ((@IsNull_iParentId = 1 AND [iParentId] IS NULL) OR ([iParentId] = @Original_iParentId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemTitle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cItemDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblItems] ([cItemTitle], [cItemKey], [cItemDescription], [iParentId]) VALUES (@cItemTitle, @cItemKey, @cItemDescription, @iParentId);
SELECT iItemID, cItemTitle, cItemKey, cItemDescription, iParentId FROM tblItems WHERE (iItemID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cItemDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblItems.*
FROM            tblItems</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblItems] SET [cItemTitle] = @cItemTitle, [cItemKey] = @cItemKey, [cItemDescription] = @cItemDescription, [iParentId] = @iParentId WHERE (([iItemID] = @Original_iItemID) AND ((@IsNull_cItemTitle = 1 AND [cItemTitle] IS NULL) OR ([cItemTitle] = @Original_cItemTitle)) AND ((@IsNull_cItemKey = 1 AND [cItemKey] IS NULL) OR ([cItemKey] = @Original_cItemKey)) AND ((@IsNull_cItemDescription = 1 AND [cItemDescription] IS NULL) OR ([cItemDescription] = @Original_cItemDescription)) AND ((@IsNull_iParentId = 1 AND [iParentId] IS NULL) OR ([iParentId] = @Original_iParentId)));
SELECT iItemID, cItemTitle, cItemKey, cItemDescription, iParentId FROM tblItems WHERE (iItemID = @iItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cItemDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemTitle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cItemTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemKey" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cItemKey" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cItemKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cItemDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cItemDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cItemDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cItemDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iParentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="iItemID" ColumnName="iItemID" DataSourceName="CrewManagment.dbo.tblItems" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@iItemID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="iItemID" DataSetColumn="iItemID" />
              <Mapping SourceColumn="cItemTitle" DataSetColumn="cItemTitle" />
              <Mapping SourceColumn="cItemKey" DataSetColumn="cItemKey" />
              <Mapping SourceColumn="cItemDescription" DataSetColumn="cItemDescription" />
              <Mapping SourceColumn="iParentId" DataSetColumn="iParentId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblUserProfileTableAdapter" GeneratorDataComponentClassName="tblUserProfileTableAdapter" Name="tblUserProfile" UserDataComponentName="tblUserProfileTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUserProfile" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblUserProfile] WHERE (([cUserName] = @Original_cUserName) AND ((@IsNull_Theme = 1 AND [Theme] IS NULL) OR ([Theme] = @Original_Theme)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Theme" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Theme" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblUserProfile] ([cUserName], [Theme], [XmlConfiguration]) VALUES (@cUserName, @Theme, @XmlConfiguration);
SELECT cUserName, Theme, XmlConfiguration FROM tblUserProfile WHERE (cUserName = @cUserName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Theme" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@XmlConfiguration" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="XmlConfiguration" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblUserProfile.*
FROM            tblUserProfile</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblUserProfile] SET [cUserName] = @cUserName, [Theme] = @Theme, [XmlConfiguration] = @XmlConfiguration WHERE (([cUserName] = @Original_cUserName) AND ((@IsNull_Theme = 1 AND [Theme] IS NULL) OR ([Theme] = @Original_Theme)));
SELECT cUserName, Theme, XmlConfiguration FROM tblUserProfile WHERE (cUserName = @cUserName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Theme" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@XmlConfiguration" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="XmlConfiguration" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Theme" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Theme" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cUserName" DataSetColumn="cUserName" />
              <Mapping SourceColumn="Theme" DataSetColumn="Theme" />
              <Mapping SourceColumn="XmlConfiguration" DataSetColumn="XmlConfiguration" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblUserProfile" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="getTheme" Modifier="Public" Name="getTheme" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getTheme">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Theme FROM tblUserProfile
where cUserName=@username</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblUserProfile" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="setDefautTheme" Modifier="Public" Name="setDefautTheme" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="setDefautTheme">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [tblUserProfile] SET [Theme] = @Theme WHERE ([cUserName] = @Original_cUserName)
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Theme" ColumnName="Theme" DataSourceName="CrewManagment.dbo.tblUserProfile" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Theme" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_cUserName" ColumnName="cUserName" DataSourceName="CrewManagment.dbo.tblUserProfile" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_cUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="cUserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsUsers" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msdata:EnforceConstraints="False" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsUsers" msprop:Generator_UserDSName="dsUsers">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblUsers" msprop:Generator_TableClassName="tblUsersDataTable" msprop:Generator_TableVarName="tabletblUsers" msprop:Generator_TablePropName="tblUsers" msprop:Generator_RowDeletingName="tblUsersRowDeleting" msprop:Generator_UserTableName="tblUsers" msprop:Generator_RowChangingName="tblUsersRowChanging" msprop:Generator_RowEvHandlerName="tblUsersRowChangeEventHandler" msprop:Generator_RowDeletedName="tblUsersRowDeleted" msprop:Generator_RowEvArgName="tblUsersRowChangeEvent" msprop:Generator_RowChangedName="tblUsersRowChanged" msprop:Generator_RowClassName="tblUsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idNhanSu" msprop:Generator_ColumnVarNameInTable="columnidNhanSu" msprop:Generator_ColumnPropNameInRow="idNhanSu" msprop:Generator_ColumnPropNameInTable="idNhanSuColumn" msprop:Generator_UserColumnName="idNhanSu" type="xs:int" minOccurs="0" />
              <xs:element name="idPhong" msprop:Generator_ColumnVarNameInTable="columnidPhong" msprop:Generator_ColumnPropNameInRow="idPhong" msprop:Generator_ColumnPropNameInTable="idPhongColumn" msprop:Generator_UserColumnName="idPhong" type="xs:int" minOccurs="0" />
              <xs:element name="iRoleID" msprop:Generator_ColumnVarNameInTable="columniRoleID" msprop:Generator_ColumnPropNameInRow="iRoleID" msprop:Generator_ColumnPropNameInTable="iRoleIDColumn" msprop:Generator_UserColumnName="iRoleID" type="xs:int" minOccurs="0" />
              <xs:element name="cUserName" msprop:Generator_ColumnVarNameInTable="columncUserName" msprop:Generator_ColumnPropNameInRow="cUserName" msprop:Generator_ColumnPropNameInTable="cUserNameColumn" msprop:Generator_UserColumnName="cUserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPassword" msprop:Generator_ColumnVarNameInTable="columncPassword" msprop:Generator_ColumnPropNameInRow="cPassword" msprop:Generator_ColumnPropNameInTable="cPasswordColumn" msprop:Generator_UserColumnName="cPassword" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bActive" msprop:Generator_ColumnVarNameInTable="columnbActive" msprop:Generator_ColumnPropNameInRow="bActive" msprop:Generator_ColumnPropNameInTable="bActiveColumn" msprop:Generator_UserColumnName="bActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="bIsAdmin" msprop:Generator_ColumnVarNameInTable="columnbIsAdmin" msprop:Generator_ColumnPropNameInRow="bIsAdmin" msprop:Generator_ColumnPropNameInTable="bIsAdminColumn" msprop:Generator_UserColumnName="bIsAdmin" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblPhong" msprop:Generator_TableClassName="tblPhongDataTable" msprop:Generator_TableVarName="tabletblPhong" msprop:Generator_TablePropName="tblPhong" msprop:Generator_RowDeletingName="tblPhongRowDeleting" msprop:Generator_UserTableName="tblPhong" msprop:Generator_RowChangingName="tblPhongRowChanging" msprop:Generator_RowEvHandlerName="tblPhongRowChangeEventHandler" msprop:Generator_RowDeletedName="tblPhongRowDeleted" msprop:Generator_RowEvArgName="tblPhongRowChangeEvent" msprop:Generator_RowChangedName="tblPhongRowChanged" msprop:Generator_RowClassName="tblPhongRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="iPhongId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columniPhongId" msprop:Generator_ColumnPropNameInRow="iPhongId" msprop:Generator_ColumnPropNameInTable="iPhongIdColumn" msprop:Generator_UserColumnName="iPhongId" type="xs:int" />
              <xs:element name="cTenPhong" msprop:Generator_ColumnVarNameInTable="columncTenPhong" msprop:Generator_ColumnPropNameInRow="cTenPhong" msprop:Generator_ColumnPropNameInTable="cTenPhongColumn" msprop:Generator_UserColumnName="cTenPhong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMoTa" msprop:Generator_ColumnVarNameInTable="columncMoTa" msprop:Generator_ColumnPropNameInRow="cMoTa" msprop:Generator_ColumnPropNameInTable="cMoTaColumn" msprop:Generator_UserColumnName="cMoTa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblRole" msprop:Generator_TableClassName="tblRoleDataTable" msprop:Generator_TableVarName="tabletblRole" msprop:Generator_TablePropName="tblRole" msprop:Generator_RowDeletingName="tblRoleRowDeleting" msprop:Generator_UserTableName="tblRole" msprop:Generator_RowChangingName="tblRoleRowChanging" msprop:Generator_RowEvHandlerName="tblRoleRowChangeEventHandler" msprop:Generator_RowDeletedName="tblRoleRowDeleted" msprop:Generator_RowEvArgName="tblRoleRowChangeEvent" msprop:Generator_RowChangedName="tblRoleRowChanged" msprop:Generator_RowClassName="tblRoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="iRoleid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columniRoleid" msprop:Generator_ColumnPropNameInRow="iRoleid" msprop:Generator_ColumnPropNameInTable="iRoleidColumn" msprop:Generator_UserColumnName="iRoleid" type="xs:int" />
              <xs:element name="cTenRole" msprop:Generator_ColumnVarNameInTable="columncTenRole" msprop:Generator_ColumnPropNameInRow="cTenRole" msprop:Generator_ColumnPropNameInTable="cTenRoleColumn" msprop:Generator_UserColumnName="cTenRole" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMoTa" msprop:Generator_ColumnVarNameInTable="columncMoTa" msprop:Generator_ColumnPropNameInRow="cMoTa" msprop:Generator_ColumnPropNameInTable="cMoTaColumn" msprop:Generator_UserColumnName="cMoTa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bActive" msprop:Generator_ColumnVarNameInTable="columnbActive" msprop:Generator_ColumnPropNameInRow="bActive" msprop:Generator_ColumnPropNameInTable="bActiveColumn" msprop:Generator_UserColumnName="bActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="bIsAdmin" msprop:Generator_ColumnVarNameInTable="columnbIsAdmin" msprop:Generator_ColumnPropNameInRow="bIsAdmin" msprop:Generator_ColumnPropNameInTable="bIsAdminColumn" msprop:Generator_UserColumnName="bIsAdmin" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblNhanSu" msprop:Generator_TableClassName="tblNhanSuDataTable" msprop:Generator_TableVarName="tabletblNhanSu" msprop:Generator_TablePropName="tblNhanSu" msprop:Generator_RowDeletingName="tblNhanSuRowDeleting" msprop:Generator_UserTableName="tblNhanSu" msprop:Generator_RowChangingName="tblNhanSuRowChanging" msprop:Generator_RowEvHandlerName="tblNhanSuRowChangeEventHandler" msprop:Generator_RowDeletedName="tblNhanSuRowDeleted" msprop:Generator_RowEvArgName="tblNhanSuRowChangeEvent" msprop:Generator_RowChangedName="tblNhanSuRowChanged" msprop:Generator_RowClassName="tblNhanSuRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cTenNhanSu" msprop:Generator_ColumnVarNameInTable="columncTenNhanSu" msprop:Generator_ColumnPropNameInRow="cTenNhanSu" msprop:Generator_ColumnPropNameInTable="cTenNhanSuColumn" msprop:Generator_UserColumnName="cTenNhanSu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iPhongID" msprop:Generator_ColumnVarNameInTable="columniPhongID" msprop:Generator_ColumnPropNameInRow="iPhongID" msprop:Generator_ColumnPropNameInTable="iPhongIDColumn" msprop:Generator_UserColumnName="iPhongID" type="xs:int" minOccurs="0" />
              <xs:element name="cDiaChi" msprop:Generator_ColumnVarNameInTable="columncDiaChi" msprop:Generator_ColumnPropNameInRow="cDiaChi" msprop:Generator_ColumnPropNameInTable="cDiaChiColumn" msprop:Generator_UserColumnName="cDiaChi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pAnhDaiDien" msprop:Generator_ColumnVarNameInTable="columnpAnhDaiDien" msprop:Generator_ColumnPropNameInRow="pAnhDaiDien" msprop:Generator_ColumnPropNameInTable="pAnhDaiDienColumn" msprop:Generator_UserColumnName="pAnhDaiDien" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="cEmail" msprop:Generator_ColumnVarNameInTable="columncEmail" msprop:Generator_ColumnPropNameInRow="cEmail" msprop:Generator_ColumnPropNameInTable="cEmailColumn" msprop:Generator_UserColumnName="cEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cSoDienThoai" msprop:Generator_ColumnVarNameInTable="columncSoDienThoai" msprop:Generator_ColumnPropNameInRow="cSoDienThoai" msprop:Generator_ColumnPropNameInTable="cSoDienThoaiColumn" msprop:Generator_UserColumnName="cSoDienThoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dNgaySinh" msprop:Generator_ColumnVarNameInTable="columndNgaySinh" msprop:Generator_ColumnPropNameInRow="dNgaySinh" msprop:Generator_ColumnPropNameInTable="dNgaySinhColumn" msprop:Generator_UserColumnName="dNgaySinh" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cChucVu" msprop:Generator_ColumnVarNameInTable="columncChucVu" msprop:Generator_ColumnPropNameInRow="cChucVu" msprop:Generator_ColumnPropNameInTable="cChucVuColumn" msprop:Generator_UserColumnName="cChucVu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isMale" msprop:Generator_ColumnVarNameInTable="columnisMale" msprop:Generator_ColumnPropNameInRow="isMale" msprop:Generator_ColumnPropNameInTable="isMaleColumn" msprop:Generator_UserColumnName="isMale" type="xs:boolean" minOccurs="0" />
              <xs:element name="iNhanSuID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columniNhanSuID" msprop:Generator_ColumnPropNameInRow="iNhanSuID" msprop:Generator_ColumnPropNameInTable="iNhanSuIDColumn" msprop:Generator_UserColumnName="iNhanSuID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblQuyen" msprop:Generator_TableClassName="tblQuyenDataTable" msprop:Generator_TableVarName="tabletblQuyen" msprop:Generator_TablePropName="tblQuyen" msprop:Generator_RowDeletingName="tblQuyenRowDeleting" msprop:Generator_UserTableName="tblQuyen" msprop:Generator_RowChangingName="tblQuyenRowChanging" msprop:Generator_RowEvHandlerName="tblQuyenRowChangeEventHandler" msprop:Generator_RowDeletedName="tblQuyenRowDeleted" msprop:Generator_RowEvArgName="tblQuyenRowChangeEvent" msprop:Generator_RowChangedName="tblQuyenRowChanged" msprop:Generator_RowClassName="tblQuyenRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="iQuyenID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columniQuyenID" msprop:Generator_ColumnPropNameInRow="iQuyenID" msprop:Generator_ColumnPropNameInTable="iQuyenIDColumn" msprop:Generator_UserColumnName="iQuyenID" type="xs:int" />
              <xs:element name="cUserName" msprop:Generator_ColumnVarNameInTable="columncUserName" msprop:Generator_ColumnPropNameInRow="cUserName" msprop:Generator_ColumnPropNameInTable="cUserNameColumn" msprop:Generator_UserColumnName="cUserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iItemID" msprop:Generator_ColumnVarNameInTable="columniItemID" msprop:Generator_ColumnPropNameInRow="iItemID" msprop:Generator_ColumnPropNameInTable="iItemIDColumn" msprop:Generator_UserColumnName="iItemID" type="xs:int" />
              <xs:element name="cItemTitle" msprop:Generator_ColumnVarNameInTable="columncItemTitle" msprop:Generator_ColumnPropNameInRow="cItemTitle" msprop:Generator_ColumnPropNameInTable="cItemTitleColumn" msprop:Generator_UserColumnName="cItemTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cItemKey" msprop:Generator_ColumnVarNameInTable="columncItemKey" msprop:Generator_ColumnPropNameInRow="cItemKey" msprop:Generator_ColumnPropNameInTable="cItemKeyColumn" msprop:Generator_UserColumnName="cItemKey" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iParentID" msprop:Generator_ColumnVarNameInTable="columniParentID" msprop:Generator_ColumnPropNameInRow="iParentID" msprop:Generator_ColumnPropNameInTable="iParentIDColumn" msprop:Generator_UserColumnName="iParentID" type="xs:int" minOccurs="0" />
              <xs:element name="cTenQuyen" msprop:Generator_ColumnVarNameInTable="columncTenQuyen" msprop:Generator_ColumnPropNameInRow="cTenQuyen" msprop:Generator_ColumnPropNameInTable="cTenQuyenColumn" msprop:Generator_UserColumnName="cTenQuyen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMoTa" msprop:Generator_ColumnVarNameInTable="columncMoTa" msprop:Generator_ColumnPropNameInRow="cMoTa" msprop:Generator_ColumnPropNameInTable="cMoTaColumn" msprop:Generator_UserColumnName="cMoTa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bFull" msprop:Generator_ColumnVarNameInTable="columnbFull" msprop:Generator_ColumnPropNameInRow="bFull" msprop:Generator_ColumnPropNameInTable="bFullColumn" msprop:Generator_UserColumnName="bFull" type="xs:boolean" minOccurs="0" />
              <xs:element name="bTruyCap" msprop:Generator_ColumnVarNameInTable="columnbTruyCap" msprop:Generator_ColumnPropNameInRow="bTruyCap" msprop:Generator_ColumnPropNameInTable="bTruyCapColumn" msprop:Generator_UserColumnName="bTruyCap" type="xs:boolean" minOccurs="0" />
              <xs:element name="bThem" msprop:Generator_ColumnVarNameInTable="columnbThem" msprop:Generator_ColumnPropNameInRow="bThem" msprop:Generator_ColumnPropNameInTable="bThemColumn" msprop:Generator_UserColumnName="bThem" type="xs:boolean" minOccurs="0" />
              <xs:element name="bSua" msprop:Generator_ColumnVarNameInTable="columnbSua" msprop:Generator_ColumnPropNameInRow="bSua" msprop:Generator_ColumnPropNameInTable="bSuaColumn" msprop:Generator_UserColumnName="bSua" type="xs:boolean" minOccurs="0" />
              <xs:element name="bXoa" msprop:Generator_ColumnVarNameInTable="columnbXoa" msprop:Generator_ColumnPropNameInRow="bXoa" msprop:Generator_ColumnPropNameInTable="bXoaColumn" msprop:Generator_UserColumnName="bXoa" type="xs:boolean" minOccurs="0" />
              <xs:element name="bIn" msprop:Generator_ColumnVarNameInTable="columnbIn" msprop:Generator_ColumnPropNameInRow="bIn" msprop:Generator_ColumnPropNameInTable="bInColumn" msprop:Generator_UserColumnName="bIn" type="xs:boolean" minOccurs="0" />
              <xs:element name="bNhap" msprop:Generator_ColumnVarNameInTable="columnbNhap" msprop:Generator_ColumnPropNameInRow="bNhap" msprop:Generator_ColumnPropNameInTable="bNhapColumn" msprop:Generator_UserColumnName="bNhap" type="xs:boolean" minOccurs="0" />
              <xs:element name="bXuat" msprop:Generator_ColumnVarNameInTable="columnbXuat" msprop:Generator_ColumnPropNameInRow="bXuat" msprop:Generator_ColumnPropNameInTable="bXuatColumn" msprop:Generator_UserColumnName="bXuat" type="xs:boolean" minOccurs="0" />
              <xs:element name="isAdmin" msprop:Generator_ColumnVarNameInTable="columnisAdmin" msprop:Generator_ColumnPropNameInRow="isAdmin" msprop:Generator_ColumnPropNameInTable="isAdminColumn" msprop:Generator_UserColumnName="isAdmin" type="xs:boolean" minOccurs="0" />
              <xs:element name="ControlInMain" msprop:Generator_ColumnVarNameInTable="columnControlInMain" msprop:Generator_ColumnPropNameInRow="ControlInMain" msprop:Generator_ColumnPropNameInTable="ControlInMainColumn" msprop:Generator_UserColumnName="ControlInMain" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblItems" msprop:Generator_TableClassName="tblItemsDataTable" msprop:Generator_TableVarName="tabletblItems" msprop:Generator_TablePropName="tblItems" msprop:Generator_RowDeletingName="tblItemsRowDeleting" msprop:Generator_UserTableName="tblItems" msprop:Generator_RowChangingName="tblItemsRowChanging" msprop:Generator_RowEvHandlerName="tblItemsRowChangeEventHandler" msprop:Generator_RowDeletedName="tblItemsRowDeleted" msprop:Generator_RowEvArgName="tblItemsRowChangeEvent" msprop:Generator_RowChangedName="tblItemsRowChanged" msprop:Generator_RowClassName="tblItemsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="iItemID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columniItemID" msprop:Generator_ColumnPropNameInRow="iItemID" msprop:Generator_ColumnPropNameInTable="iItemIDColumn" msprop:Generator_UserColumnName="iItemID" type="xs:int" />
              <xs:element name="cItemTitle" msprop:Generator_ColumnVarNameInTable="columncItemTitle" msprop:Generator_ColumnPropNameInRow="cItemTitle" msprop:Generator_ColumnPropNameInTable="cItemTitleColumn" msprop:Generator_UserColumnName="cItemTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cItemKey" msprop:Generator_ColumnVarNameInTable="columncItemKey" msprop:Generator_ColumnPropNameInRow="cItemKey" msprop:Generator_ColumnPropNameInTable="cItemKeyColumn" msprop:Generator_UserColumnName="cItemKey" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cItemDescription" msprop:Generator_ColumnVarNameInTable="columncItemDescription" msprop:Generator_ColumnPropNameInRow="cItemDescription" msprop:Generator_ColumnPropNameInTable="cItemDescriptionColumn" msprop:Generator_UserColumnName="cItemDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iParentId" msprop:Generator_ColumnVarNameInTable="columniParentId" msprop:Generator_ColumnPropNameInRow="iParentId" msprop:Generator_ColumnPropNameInTable="iParentIdColumn" msprop:Generator_UserColumnName="iParentId" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblUserProfile" msprop:Generator_TableClassName="tblUserProfileDataTable" msprop:Generator_TableVarName="tabletblUserProfile" msprop:Generator_TablePropName="tblUserProfile" msprop:Generator_RowDeletingName="tblUserProfileRowDeleting" msprop:Generator_UserTableName="tblUserProfile" msprop:Generator_RowChangingName="tblUserProfileRowChanging" msprop:Generator_RowEvHandlerName="tblUserProfileRowChangeEventHandler" msprop:Generator_RowDeletedName="tblUserProfileRowDeleted" msprop:Generator_RowEvArgName="tblUserProfileRowChangeEvent" msprop:Generator_RowChangedName="tblUserProfileRowChanged" msprop:Generator_RowClassName="tblUserProfileRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cUserName" msprop:Generator_ColumnVarNameInTable="columncUserName" msprop:Generator_ColumnPropNameInRow="cUserName" msprop:Generator_ColumnPropNameInTable="cUserNameColumn" msprop:Generator_UserColumnName="cUserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Theme" msprop:Generator_ColumnVarNameInTable="columnTheme" msprop:Generator_ColumnPropNameInRow="Theme" msprop:Generator_ColumnPropNameInTable="ThemeColumn" msprop:Generator_UserColumnName="Theme" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="XmlConfiguration" msprop:Generator_ColumnVarNameInTable="columnXmlConfiguration" msprop:Generator_ColumnPropNameInRow="XmlConfiguration" msprop:Generator_ColumnPropNameInTable="XmlConfigurationColumn" msprop:Generator_UserColumnName="XmlConfiguration" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblUsers" />
      <xs:field xpath="mstns:cUserName" />
    </xs:unique>
    <xs:unique name="tblPhong_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblPhong" />
      <xs:field xpath="mstns:iPhongId" />
    </xs:unique>
    <xs:unique name="tblRole_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblRole" />
      <xs:field xpath="mstns:iRoleid" />
    </xs:unique>
    <xs:unique name="tblNhanSu_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblNhanSu" />
      <xs:field xpath="mstns:iNhanSuID" />
    </xs:unique>
    <xs:unique name="tblQuyen_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblQuyen" />
      <xs:field xpath="mstns:cUserName" />
      <xs:field xpath="mstns:iItemID" />
    </xs:unique>
    <xs:unique name="tblItems_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblItems" />
      <xs:field xpath="mstns:iItemID" />
    </xs:unique>
    <xs:unique name="tblUserProfile_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblUserProfile" />
      <xs:field xpath="mstns:cUserName" />
    </xs:unique>
    <xs:keyref name="FK_tblQuyen_tblUsers" refer="Constraint1" msprop:rel_Generator_UserChildTable="tblQuyen" msprop:rel_Generator_ChildPropName="GettblQuyenRows" msprop:rel_Generator_UserParentTable="tblUsers" msprop:rel_Generator_UserRelationName="FK_tblQuyen_tblUsers1" msprop:rel_Generator_RelationVarName="relationFK_tblQuyen_tblUsers1" msprop:rel_Generator_ParentPropName="tblUsersRow" msdata:RelationName="FK_tblQuyen_tblUsers1">
      <xs:selector xpath=".//mstns:tblQuyen" />
      <xs:field xpath="mstns:cUserName" />
    </xs:keyref>
    <xs:keyref name="tblNhanSu_tblUsers" refer="tblNhanSu_Constraint1" msdata:ConstraintOnly="true">
      <xs:selector xpath=".//mstns:tblUsers" />
      <xs:field xpath="mstns:idNhanSu" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblUsers_tblRole" msdata:parent="tblRole" msdata:child="tblUsers" msdata:parentkey="iRoleid" msdata:childkey="iRoleID" msprop:Generator_UserChildTable="tblUsers" msprop:Generator_ChildPropName="GettblUsersRows" msprop:Generator_ParentPropName="tblRoleRow" msprop:Generator_UserRelationName="FK_tblUsers_tblRole" msprop:Generator_RelationVarName="relationFK_tblUsers_tblRole" msprop:Generator_UserParentTable="tblRole" />
      <msdata:Relationship name="FK_tblQuyen_tblItems" msdata:parent="tblItems" msdata:child="tblQuyen" msdata:parentkey="iItemID" msdata:childkey="iItemID" msprop:Generator_UserChildTable="tblQuyen" msprop:Generator_ChildPropName="GettblQuyenRows" msprop:Generator_UserParentTable="tblItems" msprop:Generator_UserRelationName="FK_tblQuyen_tblItems" msprop:Generator_RelationVarName="relationFK_tblQuyen_tblItems" msprop:Generator_ParentPropName="tblItemsRow" />
      <msdata:Relationship name="FK_tblUserProfile_tblUsers" msdata:parent="tblUsers" msdata:child="tblUserProfile" msdata:parentkey="cUserName" msdata:childkey="cUserName" msprop:Generator_UserChildTable="tblUserProfile" msprop:Generator_ChildPropName="GettblUserProfileRows" msprop:Generator_ParentPropName="tblUsersRow" msprop:Generator_UserRelationName="FK_tblUserProfile_tblUsers" msprop:Generator_RelationVarName="relationFK_tblUserProfile_tblUsers" msprop:Generator_UserParentTable="tblUsers" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>